package com.shelpe.services.algorithm.repository.batis;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.shelpe.services.algorithm.entity.batis.RptKeyword;
import com.shelpe.services.algorithm.entity.batis.RptKeywordExample;

public interface RptKeywordMapper {    
    List<RptKeyword> reportAverage(@Param("adgroup_id")long adgroupIDs, @Param("user_id") long userID,
    		@Param("from")String from, @Param("to")String to,
    		@Param("lower_limit")int lower, @Param("upper_limit")int upper);
    List<RptKeyword> reportMax(@Param("adgroup_id")long adgroupIDs, @Param("user_id") long userID, 
    		@Param("from")String from, @Param("to")String to,
    		@Param("lower_limit")int lower, @Param("upper_limit")int upper);
    
    List<RptKeyword> selectByExample(RptKeywordExample example);

    List<RptKeyword> selectSumByExample(RptKeywordExample example);
    
}